<?php

class SiteController extends Controller
{
	/**
	 * Declares class-based actions.
	 */
	public function actions()
	{
		return array(
			// captcha action renders the CAPTCHA image displayed on the contact page
			'captcha'=>array(
				'class'=>'CCaptchaAction',
				'backColor'=>0xFFFFFF,
			),
			// page action renders "static" pages stored under 'protected/views/site/pages'
			// They can be accessed via: index.php?r=site/page&view=FileName
			'page'=>array(
				'class'=>'CViewAction',
			),
		);
	}

	/**
	 * This is the default 'index' action that is invoked
	 * when an action is not explicitly requested by users.
	 */
	public function actionIndex()
	{
		// renders the view file 'protected/views/site/index.php'
		// using the default layout 'protected/views/layouts/main.php'
		$this->render('index');
	}

	/**
	 * This is the action to handle external exceptions.
	 */
	public function actionError()
	{
	    if($error=Yii::app()->errorHandler->error)
	    {
	    	if(Yii::app()->request->isAjaxRequest)
	    		echo $error['message'];
	    	else
	        	$this->render('error', $error);
	    }
	}

	/**
	 * Displays the contact page
	 */
	public function actionContact()
	{
		$model=new ContactForm;
		if(isset($_POST['ContactForm']))
		{
			$model->attributes=$_POST['ContactForm'];
			if($model->validate())
			{
				$headers="From: {$model->email}\r\nReply-To: {$model->email}";
				mail(Yii::app()->params['adminEmail'],$model->subject,$model->body,$headers);
				Yii::app()->user->setFlash('contact','Thank you for contacting us. We will respond to you as soon as possible.');
				$this->refresh();
			}
		}
		$this->render('contact',array('model'=>$model));
	}

	/**
	 * Displays the login page
	 */
	public function actionLogin()
	{
		$model=new LoginForm;

		// if it is ajax validation request
		if(isset($_POST['ajax']) && $_POST['ajax']==='login-form')
		{
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}

		// collect user input data
		if(isset($_POST['LoginForm']))
		{
			$model->attributes=$_POST['LoginForm'];
			// validate user input and redirect to the previous page if valid
			if($model->validate() && $model->login()){
				$this->loguearBitacora();
				$this->redirect(Yii::app()->user->returnUrl);
			}
		}
		// display the login form
		$this->render('login',array('model'=>$model));
	}

	private function loguearBitacora(){
		$bita = new TbBitacora();
		$bita->descripcion='Ingresar al sistema';
		$bita->fecha = Yii::app()->db->createCommand('SELECT curdate()')->queryScalar();
		//$bita->hora = date('H:i:s');
		$bita->hora = Yii::app()->db->createCommand('SELECT curtime()')->queryScalar();
		$Accion = TbTipoaccion::model()->findByAttributes(array('accion'=>'Ingreso'));
		$bita->tb_tipoaccion_idtb_tipoaccion = $Accion->idtb_tipoaccion;
		$bita->tb_usuarios_login = Yii::app()->user->Name;
		$bita->save();
		$this->iniciarHorario($bita->fecha,$bita->hora,$bita->tb_usuarios_login);
		$usu = TbUsuarios::model()->findByPk(Yii::app()->user->Name);
		$usu->estado=2;
		$usu->save();
		
	}
	private function desloguearBitacora(){
		$bita = new TbBitacora();
		$bita->descripcion='Salir del sistema';
		$bita->fecha = Yii::app()->db->createCommand('SELECT curdate()')->queryScalar();
				//$bita->hora = date('H:i:s');
		$bita->hora = Yii::app()->db->createCommand('SELECT curtime()')->queryScalar();
		$Accion = TbTipoaccion::model()->findByAttributes(array('accion'=>'Salida'));
		$bita->tb_tipoaccion_idtb_tipoaccion = $Accion->idtb_tipoaccion;
		$bita->tb_usuarios_login = Yii::app()->user->Name;
		$bita->save();
		$this->terminarHorario($bita->fecha,$bita->hora,$bita->tb_usuarios_login);
		$usu = TbUsuarios::model()->findByPk(Yii::app()->user->Name);
		$usu->estado=1;
		$usu->save();
	}
	private function iniciarHorario($fe, $ho, $usu){
		$h = new TbHorario();
		$h->Fecha = $fe;
		$h->HoraInicio = $ho;
		$h->tb_usuarios_login = $usu;
		$h->tiempo = 0;
		$h->save();
	}
	private function terminarHorario($fe, $ho, $usu){
		$idhor = Yii::app()->db->createCommand('SELECT MAX(idtb_horario) from tb_horario where tb_usuarios_login="'.$usu.'"')->queryScalar();
		$h = TbHorario::model()->findByPk($idhor);
		$h->HoraFin = $ho;
		//$h->tiempo = Yii::app()->db->createCommand('SELECT (curtime()-HoraInicio) from tb_horario where idtb_horario="'.$idhor.'"')->queryScalar();
		$ti = date("H:i:s",strtotime('00:00:00')+strtotime($ho)-strtotime($h->HoraInicio));
		$val = explode(":",$ti);
		$h->tiempo = $val[0]*3600 + $val[1]*60 + $val[2];
		$h->save();
	}
	/**
	 * Logs out the current user and redirect to homepage.
	 */
	public function actionLogout()
	{
		$this->desloguearBitacora();
		Yii::app()->user->logout();
		$this->redirect(Yii::app()->homeUrl);
	}
}